package com.lzw.DailyAudit.service.dateAggregation_02.DailyAudit.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lzw
 * @since 2025-09-11
 */
@Mapper
public interface DailyXsjl2303Mapper {

    @Select("SELECT DISTINCT dianpu AS store FROM rxh_europe.xsjl_2303")
    List<String> getStores();


    @Select("SELECT DISTINCT UPPER(orderid) AS orderid FROM rxh_europe.xsjl_2303 WHERE dianpu='oeu' AND OrderID NOT IN ('OEU20250526-1')")
    List<String> getOeuIds();


    List<String> selectSkuList(String startDate, String endDate);

}
